package com.groupsix.mapper;

import com.groupsix.entity.Student;
import com.groupsix.entity.StudentExample;
import java.util.List;
import org.apache.ibatis.annotations.Param;

public interface StudentMapper {


    /**
     * 进行分页查询
     */

    //获取总条数
    public Integer totalCount(@Param("sName") String sName, @Param("sStudentid")Integer sStudentid,
                              @Param("sClassid")Integer sClassid,@Param("sClassname")String sClassname);
    //获取用户列表
    public List<Student> getStudentList(@Param("sName") String sName, @Param("sStudentid")Integer sStudentid,@Param("sClassid")Integer sClassid,
                                        @Param("sClassname")String sClassname, @Param("currentPage")Integer currentPage, @Param("pageSize")Integer pageSize);

    public int deleteStudent(Integer sId);   //删除学生信息
    public int addStudent(Student student);   //添加学生信息
    public int updateStudent(Student student); //修改学生信息
    public Student findStudentById(Integer sId); //通过id查询学生信息
    public List<Student> getAll(); //查询全部


    int countByExample(StudentExample example);

    int deleteByExample(StudentExample example);

    int deleteByPrimaryKey(Integer sId);

    int insert(Student record);

    int insertSelective(Student record);

    List<Student> selectByExample(StudentExample example);

    Student selectByPrimaryKey(Integer sId);

    int updateByExampleSelective(@Param("record") Student record, @Param("example") StudentExample example);

    int updateByExample(@Param("record") Student record, @Param("example") StudentExample example);

    int updateByPrimaryKeySelective(Student record);

    int updateByPrimaryKey(Student record);
}